create or replace PROCEDURE RESET_LOGS AS 
msg varchar2(128);
BEGIN
  execute immediate 'TRUNCATE TABLE DEBUG_LOG REUSE STORAGE';
  execute immediate 'TRUNCATE TABLE JOB_LOGGER REUSE STORAGE';
  execute immediate 'TRUNCATE TABLE SQL_LOG REUSE STORAGE';
  msg := 'truncate table on:'||SYSDATE;
  DEBUG_LOGGER(msg); 
  LOG_SQL(msg);
  JOB_LOGGER_PRC('RESET_LOGS',msg);
END RESET_LOGS;